IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].GetProjectEndPeriod') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].GetProjectEndPeriod
GO
CREATE PROCEDURE dbo.GetProjectEndPeriod
AS
BEGIN

	CREATE TABLE #MyTempTable (ProjectEndPeriod INT, Description varchar(100));
	INSERT INTO #MyTempTable VALUES (30, 'Projects Ending 30');
	INSERT INTO #MyTempTable VALUES (60, 'Projects Ending 60');
	INSERT INTO #MyTempTable VALUES (90, 'Projects Ending 90');

	select * from #MyTempTable

	drop table #MyTempTable

END